UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gL1eyAkO6e7G0EdZpd6rJxPIu6VJ1ZVxSz9s1JVgKyw='
WHERE
key_id = 'ceb8f17baf53725f2b1c0b501b0aba92f2951a095d0e5e782d1f3d8ab4d7cb62'
AND (
token = 'gL1eyAkO6e7G0EdZpd6rJxPIu6VJ1ZVxSz9s1JVgKyw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)