UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bGkjiG+SXpXVFYBojfRhY6E1Eht00kL34sO7R6mzkZU='
WHERE
key_id = '471c64119f9e84f660bb2a544b21df0b775e78d54d134e59163e7dce684510b5'
AND (
token = 'bGkjiG+SXpXVFYBojfRhY6E1Eht00kL34sO7R6mzkZU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)