UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N8wUALDvqdfA1ngkyfxfuEqYXwn051F/lDIgUWjnL8g='
WHERE
key_id = '3b4be98548e91e48e1f713821fcae177e5a48989301812163af78ae374697090'
AND (
token = 'N8wUALDvqdfA1ngkyfxfuEqYXwn051F/lDIgUWjnL8g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)