UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3R8T0TQShA8w8H35CvJp257fJ7aibTgHOPgf0y2LdHk='
WHERE
key_id = 'db67d96072fd486e114c406a5c35fe84ca0e5f6ee5e193e5d9edd9665e891d19'
AND (
token = '3R8T0TQShA8w8H35CvJp257fJ7aibTgHOPgf0y2LdHk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)