UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'htGgT0o4olQwXB6FUQJaPGy+QWtKSz23gBZcl7W8hZ8='
WHERE
key_id = '28a08563e453bfa7af56788c980eca08f5b0bdfbc0ff18b816283d3af1f75c89'
AND (
token = 'htGgT0o4olQwXB6FUQJaPGy+QWtKSz23gBZcl7W8hZ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)