UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zL7eV+dga2sSSV5r8HEudKRDe/bg9LuiuEXWluQcf9s='
WHERE
key_id = '4e53b4f327f70d1551c7d54031cc84b3a7c5019d289733a1d34f6a6065598f8d'
AND (
token = 'zL7eV+dga2sSSV5r8HEudKRDe/bg9LuiuEXWluQcf9s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)