UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CNmU/TxwYqKwhozgPNaVbYfxGC8A1GJkszRlbAI6xTQ='
WHERE
key_id = 'a18c046d01bfa38092243e05ab2f7131b8b0f7bc91ab05bdf9b05e757ea2a779'
AND (
token = 'CNmU/TxwYqKwhozgPNaVbYfxGC8A1GJkszRlbAI6xTQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)