UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fhQoOwFpjZvEwDejOd5Ggu8refUzVaRng9b6MXN+CZo='
WHERE
key_id = '4dda34ebbb701731b2180683302b7d71e11de90f0b0e30b4d3e96f42f8fa769b'
AND (
token = 'fhQoOwFpjZvEwDejOd5Ggu8refUzVaRng9b6MXN+CZo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)