UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RMk5aQodp0z7DDYpTTI2j3xgvk3rTKHYFma0BvPokC0='
WHERE
key_id = '94febffdcab5893d04b6dc82f39363d1e38991b3a85f899e6140f7c411b15a63'
AND (
token = 'RMk5aQodp0z7DDYpTTI2j3xgvk3rTKHYFma0BvPokC0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)