UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nXKjPKSBxQCfRpodn25G7HKzE0j2gv9A9fB8GFYn+Zk='
WHERE
key_id = 'fd44da237a6b55a66cf51d054fae49eba5f3238e883dac9bc28def674029c67a'
AND (
token = 'nXKjPKSBxQCfRpodn25G7HKzE0j2gv9A9fB8GFYn+Zk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)