UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6fLI8g9Ou3gj+jLdy7AdBdQBrJmdoWxds2GCplcT3dU='
WHERE
key_id = 'e1da78706ac7ac3292d979434d687c5c07897806060942e64fa697c4ddb92f00'
AND (
token = '6fLI8g9Ou3gj+jLdy7AdBdQBrJmdoWxds2GCplcT3dU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)