UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c9tFUJGOyiWvLDOGS4PAH8VexCgG6Z7vhcodpSAo/do='
WHERE
key_id = '9c6f92e927d061b9678542e08ed5938d502b99f1ebca96ca26b62cc9cbcc00e6'
AND (
token = 'c9tFUJGOyiWvLDOGS4PAH8VexCgG6Z7vhcodpSAo/do='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)