UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p7xc/T8lvv0QJBK59n03xwh43wc1+q6z1nDMcfRAGPQ='
WHERE
key_id = '98a83b87776cf83099e41d9667f5e45df57e2e89982f1e25f2523dd6d84031de'
AND (
token = 'p7xc/T8lvv0QJBK59n03xwh43wc1+q6z1nDMcfRAGPQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)