UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f9pMXgjboxB0yJKJ6YX1TmJlVb0no8aY1vpq+vgpVzA='
WHERE
key_id = '1edb9ccf0ec7d68af8abc85f7a7e501645bfffd45a88a61cba78efdc8307ed1e'
AND (
token = 'f9pMXgjboxB0yJKJ6YX1TmJlVb0no8aY1vpq+vgpVzA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)