UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o1fc1KeUZJN3rYi7mYJcAFRZ+KviVGHEy6GsYpTa78Q='
WHERE
key_id = '99c20572f45ae01d40a9a7f7e6a695c55d2d7420cced72e1db97b668f0aa3939'
AND (
token = 'o1fc1KeUZJN3rYi7mYJcAFRZ+KviVGHEy6GsYpTa78Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)