UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yrKSiN5uZd457IZ5XZ8/4sD/7a/8GRbSg5DoQ6kM3CI='
WHERE
key_id = 'e149f02f6a2bae7705384e78a9c6f890b2e709144d8947fd7979243fe9bd3cf4'
AND (
token = 'yrKSiN5uZd457IZ5XZ8/4sD/7a/8GRbSg5DoQ6kM3CI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)