UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ia0BX7i2HiFbdo18v6EMZjSUlywKRZ1K50g45J+B/NM='
WHERE
key_id = 'a695d3dcb9763dc8fc6aab312f9092e19ab1089b4792333bb47cd6bb60200390'
AND (
token = 'ia0BX7i2HiFbdo18v6EMZjSUlywKRZ1K50g45J+B/NM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)