UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xZdZ/YFzwIrq+sLkyIsj0hXYUrEpcJ4MoDMnj9Plrys='
WHERE
key_id = 'a55de4c1a597e5d5c81cff9010665a70445c84d020a5192c948d62a90ca3d047'
AND (
token = 'xZdZ/YFzwIrq+sLkyIsj0hXYUrEpcJ4MoDMnj9Plrys='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)