UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BhRdr7bBxrb2p/a+zvQNdAWEvhcwLvqlnw+w9jIJz1Q='
WHERE
key_id = 'c1f7a6fc5540d18c1e523750683fe849cab7ee03a5d1eede113c17f7d4181dd4'
AND (
token = 'BhRdr7bBxrb2p/a+zvQNdAWEvhcwLvqlnw+w9jIJz1Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)