UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7lcRwhIiVGmUqI2c9gtZvveq7Rrrj7qvXD2e4TGhNkw='
WHERE
key_id = 'd2b91210678b062727dacb97ad936e2f4aa8d0f3c851150b775ff38f2201d5fe'
AND (
token = '7lcRwhIiVGmUqI2c9gtZvveq7Rrrj7qvXD2e4TGhNkw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)