UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7bScWx1dukuk2E3SUBC2m7UGd7hFW+bPy+ZVfgBHLFI='
WHERE
key_id = 'ca8f63af0df42ce42b411f9d609ab941c8f8d6c93d29200db714c6d32959a589'
AND (
token = '7bScWx1dukuk2E3SUBC2m7UGd7hFW+bPy+ZVfgBHLFI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)