UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'coIBos3B8mAshroBuQOKkfGSnbkgFaf5/vikk0hR9mc='
WHERE
key_id = '510739078741321f13b0027451c434b165c3f470d8d2886b2b26476c546cd995'
AND (
token = 'coIBos3B8mAshroBuQOKkfGSnbkgFaf5/vikk0hR9mc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)