UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BXliq7tkJa4N8F1aYD1F/yecJ3/hU5OSSjZct2NtUMo='
WHERE
key_id = 'a9829d557b2c250185d9b3e44bbacbd8e003f2e95dcb143beba4daf2b61914df'
AND (
token = 'BXliq7tkJa4N8F1aYD1F/yecJ3/hU5OSSjZct2NtUMo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)