UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eRcvr3PjyMCdaIU2/18tkDi03X+WgoNHs2YxlyyP47I='
WHERE
key_id = 'cae4a46b31c4242b6c44ca7b8cdc6b119d8b6193a50fd56edc3c71aa65e17ce9'
AND (
token = 'eRcvr3PjyMCdaIU2/18tkDi03X+WgoNHs2YxlyyP47I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)