UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'j1eHoq7e8Y8mz3qfu45X/HpBuPeHs4e5toB2tk49uCs='
WHERE
key_id = 'a3504d78ce97a9f396cff46245d961edc06daa78cc257855ebd6eb369504f95a'
AND (
token = 'j1eHoq7e8Y8mz3qfu45X/HpBuPeHs4e5toB2tk49uCs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)