UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VThYGT11agDOASsB9PwnoJbWrHzYzU2e6m5JZqCn5c0='
WHERE
key_id = 'ecaf11983ec768e68864488a59bcd4e748089e428165f586a6115a1a4ae69639'
AND (
token = 'VThYGT11agDOASsB9PwnoJbWrHzYzU2e6m5JZqCn5c0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)