UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K0Vf+QV4T3ipVbsxXXVV0Qt0k6XwYFGO3DB7haOpYJY='
WHERE
key_id = '2c67665e528e9c10a676c44eef939cb800ecc7179f3caf8614f30382dcf62d87'
AND (
token = 'K0Vf+QV4T3ipVbsxXXVV0Qt0k6XwYFGO3DB7haOpYJY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)