UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nkNQB0aKxpwANFreOuy4pCwN7GYV9euViDco+6lpmzI='
WHERE
key_id = '5d95ac9c597cde5c950b78535f68ee1fad50c6f63188c377c5ab027b6fed85c1'
AND (
token = 'nkNQB0aKxpwANFreOuy4pCwN7GYV9euViDco+6lpmzI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)