UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4aJTNrvDODKh72b0BN9VhaVzdHSJnaKPJvg4CUKx9oM='
WHERE
key_id = '2bc604e188183c34d8071eba4375953644fbbd68db8b87493874c8ecb46fc14d'
AND (
token = '4aJTNrvDODKh72b0BN9VhaVzdHSJnaKPJvg4CUKx9oM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)